package com.example.player.dao;

/**
 * 数据库sql常量语句
 * @author 朱文权
 * */
public interface MusicDbSQL {
    /**
     * 建表语句
     * */
    String CREATE_PLAY_LIST_TABLE="create table play_lists(\n" +
            "    pid integer primary key not null auto_increment,\n" +
            "    title text not null ,\n" +
            "    cover_path text not null \n" +
            ")";
    String CREATE_SONG_TABLE="create table songs(\n" +
            "    sid integer primary key not null auto_increment,\n" +
            "    title text not null ,\n" +
            "    artist text not null,\n" +
            "    cover_path text not null,\n" +
            "    duration integer not null \n" +
            ")";
    String CREATE_SONG_LIST_RELA="create table song_list_rela(\n" +
            "    id integer primary key not null auto_increment,\n" +
            "    pid integer not null ,\n" +
            "    sid integer not null \n" +
            ")";
}
